﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.Framework.Common.TableInfo
{
    /// <summary>
    /// 会员信息表
    /// </summary>
    public class DBCustomInfo : DBBaseInfo
    {
        /// <summary>
        /// 表名称
        /// </summary>
        /// <returns>返回表名称</returns>
        public override string GetTableName()
        {
            return "CUSTOMINFO";
        }
        /// <summary>
        /// 会员信息ID
        /// </summary>
        public int CUSTOMID { get; set; }
        /// <summary>
        /// 会员名称
        /// </summary>
        public string CNAME { get; set; }
        /// <summary>
        /// 生日
        /// </summary>
        public DateTime CBIRTHDAY { get; set; }
        /// <summary>
        /// 身高
        /// </summary>
        public string CHEIGHT { get; set; }
        /// <summary>
        /// 体重
        /// </summary>
        public string CWIGHT { get; set; }
        /// <summary>
        /// 联系电话
        /// </summary>
        public string CPHONE1 { get; set; }
        /// <summary>
        /// 联系电话
        /// </summary>
        public string CPHONE2 { get; set; }
        /// <summary>
        /// 邮政编码
        /// </summary>
        public string CZIPCODE { get; set; }
        /// <summary>
        /// 邮寄地址
        /// </summary>
        public string CADDRESS { get; set; }
        /// <summary>
        /// 快速定位码
        /// </summary>
        public string CINDEXCODE { get; set; }
        /// <summary>
        /// 会员所属店
        /// </summary>
        public int SALONID { get; set; }
        /// <summary>
        /// 注册时间
        /// </summary>
        public DateTime CREGISTERDATE { get; set; }
        /// <summary>
        /// 注销时间
        /// </summary>
        public DateTime CANCELDATE { get; set; }
        /// <summary>
        /// C0A 有效会员 C0I 注销会员 C0L 长时间不到店
        /// </summary>
        public String CSTATE { get; set; }
        /// <summary>
        /// 最后一次到店时间
        /// </summary>
        public DateTime CLASTREGISTERDATE { get; set; }
        /// <summary>
        /// 最后一次回访时间
        /// </summary>
        public string CLASTCALL { get; set; }
        /// <summary>
        /// 备注信息
        /// </summary>
        public string CMEMO { get; set; }
        /// <summary>
        /// 字段名
        /// </summary>
        public static class FieldName
        {
            /// <summary>
            /// 会员信息ID
            /// </summary>
            public const string CUSTOMID = "CUSTOMID";
            /// <summary>
            /// 会员名称
            /// </summary>
            public const string CNAME = "CNAME";
            /// <summary>
            /// 生日
            /// </summary>
            public const string CBIRTHDAY = "CBIRTHDAY";
            /// <summary>
            /// 身高
            /// </summary>
            public const string CHEIGHT = "CHEIGHT";
            /// <summary>
            /// 体重
            /// </summary>
            public const string CWIGHT = "CWIGHT";
            /// <summary>
            /// 联系电话
            /// </summary>
            public const string CPHONE1 = "CPHONE1";
            /// <summary>
            /// 联系电话
            /// </summary>
            public const string CPHONE2 = "CPHONE2";
            /// <summary>
            /// 邮政编码
            /// </summary>
            public const string CZIPCODE = "CZIPCODE";
            /// <summary>
            /// 邮寄地址
            /// </summary>
            public const string CADDRESS = "CADDRESS";
            /// <summary>
            /// 快速定位码
            /// </summary>
            public const string CINDEXCODE = "CINDEXCODE";
            /// <summary>
            /// 会员所属店
            /// </summary>
            public const string SALONID = "SALONID";
            /// <summary>
            /// 注册时间
            /// </summary>
            public const string CREGISTERDATE = "CREGISTERDATE";
            /// <summary>
            /// 注销时间
            /// </summary>
            public const string CANCELDATE = "CANCELDATE";
            /// <summary>
            /// C0A 有效会员 C0I 注销会员 C0L 长时间不到店
            /// </summary>
            public const string CSTATE = "CSTATE";
            /// <summary>
            /// 最后一次到店时间
            /// </summary>
            public const string CLASTREGISTERDATE = "CLASTREGISTERDATE";
            /// <summary>
            /// 最后一次回访时间
            /// </summary>
            public const string CLASTCALL = "CLASTCALL";
            /// <summary>
            /// 备注信息
            /// </summary>
            public const string CMEMO = "CMEMO";
        }
        /// <summary>
        ///  C0A 有效会员 C0I 注销会员 C0L 长时间不到店
        /// </summary>
        public static class ENUM_CSTATE
        {
            /// <summary>
            ///  C0A 有效会员
            /// </summary>
            public const string C0A = "C0A";
            /// <summary>
            ///  C0I 注销会员
            /// </summary>
            public const string C0I = "C0I";
            /// <summary>
            ///  C0L 长时间不到店
            /// </summary>
            public const string C0L = "C0L";
        }
    }
}
